/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_common_region.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_COMMON_REGION
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_common_region.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_COMMON_REGION::CTable_PPM_COMMON_REGION( )
 :NPCRecordSet( )
{
  setTableName( "PPM_COMMON_REGION" );
  prepareTable();
  prepareQuery();
 
  COMMON_REGION_ID.setField( "COMMON_REGION_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( COMMON_REGION_ID );
  makeKeyItem( COMMON_REGION_ID ); 
  UP_REGION_ID.setField( "UP_REGION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( UP_REGION_ID );
  REGION_NAME.setField( "REGION_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( REGION_NAME );
  REGION_CODE.setField( "REGION_CODE", DATA_CHAR, 30, 0 );
  makeTableItem( REGION_CODE );
  REGION_TYPE.setField( "REGION_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( REGION_TYPE );
  REGION_DESC.setField( "REGION_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( REGION_DESC );
}


CTable_PPM_COMMON_REGION::CTable_PPM_COMMON_REGION( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_COMMON_REGION" );
  prepareTable();
  prepareQuery();
 
  COMMON_REGION_ID.setField( "COMMON_REGION_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( COMMON_REGION_ID );
  makeKeyItem( COMMON_REGION_ID ); 
  UP_REGION_ID.setField( "UP_REGION_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( UP_REGION_ID );
  REGION_NAME.setField( "REGION_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( REGION_NAME );
  REGION_CODE.setField( "REGION_CODE", DATA_CHAR, 30, 0 );
  makeTableItem( REGION_CODE );
  REGION_TYPE.setField( "REGION_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( REGION_TYPE );
  REGION_DESC.setField( "REGION_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( REGION_DESC );
}

CTable_PPM_COMMON_REGION::~CTable_PPM_COMMON_REGION( )
{
    close();
}

